package demo.dao;

import demo.entity.Emp;
import demo.entity.EmpChild;

import java.sql.SQLException;
import java.util.List;

public interface EmpDao {
    //插入Emp
    int insertEmp(Emp emp) throws SQLException;
    //更新Emp
    int updateEmp(Emp emp) throws SQLException;
    //删除Emp
    int deleteEmp(Integer empno) throws SQLException;
    //查询全部Emp
    List<Emp> queryAllEmp() throws SQLException;
    //根据id查询Emp
    Emp queryEmpById(Integer empno) throws SQLException;
    //查询Emp总数
    Long queryCount() throws SQLException;
    //查询EmpChild
    List<EmpChild> queryEmpChildAll() throws SQLException;
}
